Main
Michael Hanna
Data Engineer leveraging 15 years of high-pressure operational experience in the energy sector looking to deliver value to a new industry and organization. Please check my cover letter here!
Professional Experience
Data Engineer
EQT Corporation
Pittsburgh, PA
Jun 2017 - Current
- Write R and SQL scripts to Extract, Transform, and Load data (ETL) from the authoritative sources to enable data-driven decisions for the business.
- Create Data Pipelines using R, Azure Data Factory, and Informatica Cloud.
- Develop insights using Tibco Spotfire, Microsoft Power BI, and R Shiny apps as needed.
- Report quarterly drilling performance and KPIs to the management.
- Create and deploy all Wellview drilling data audits to ensure data reliability.
- Manage work using cases and work items in Salesforce and repositories in Github.
Wells Performance Analyst
BP
Anchorage, Alaska
Apr 2012 - May 2017
- Develop Excel automated tools using VBA for end of well reporting, wellbore integrity testing calculator, well scorecard, and data quality audits.
- Provide support to the drilling and workover teams by responding to ad-hoc data requests, answering questions, and providing analysis.
- Act as Landmark applications point of contact for OpenWells, Compass, and Data Analyzer.
- Create and maintain GWO (Global Wells Organization) Spotfire interactive dashboards.
- Compile and manipulate data from different sources to assist with technical analysis (EDM, AWGRS, Finder, SAP Business Objects,…etc.)
- Assist in Drilling Performance Benchmarking and KPIs.
- Update the company legacy tools to comply with the new policies and best practices.
- Participate in testing of Landmark new software releases and provide acceptance criteria to the management.
Senior Drilling Data Management Engineer
MCS Freezone (Modern Computing Services)
Cairo, Egypt
Mar 2006 - Sep 2011
- Research, gather requirements, design, install, configure, troubleshoot, train, and support MCS drilling applications.
- Report the Drilling Performance, NPT, root cause analysis, and learning curve management.
- Support data acquisition, data entry, data quality control, and end of well reporting.
- Implement the first Kongsberg real-time drilling data management system in the Egyptian market.
- Install and run PMAC sand monitoring system on an offshore rig in Mauritania.
- Manage and supervise three of MCS Junior Drilling Engineers
DRILLING APPS
Proficient with Landmark EDM Suite (OpenWells, Compass, Data Analyzer, and Profile)
Proficient with Peloton Wellview
Proficient with Petrobeacon Spotlight Audit App
Proficient with Genesis Analyzer, Designer and Data Entry System (DES)
Proficient with the Drilling Performance KPIs and End of Well Reporting
SKILLS ACTIVELY LEARNING
- Python
- Azure Data Factory, Data Lake, and Databricks
- Power BI and DAX Language
- R (purrr, timevis, leaflet, zoo, and data.table)
REFERENCES
Scan this barcode with your iPhone camera to look at recommendations on my LinkedIn profile.
Additional references are available upon request.
This resume was created using the R package pagedown.
Last updated on 2020-05-26
Roughneck
Global SantaFE Corporation, Offshore Key Manhattan Jackup Rig
Port Said, Egypt
Nov 2004 - Feb 2006
Education
Cairo University - Faculty of Engineering
B.Sc. in Petroleum Engineering
Cairo, Egypt
1998 - 2003
Official Credential Evaluation Report from IERF (International Education Research Foundation) - a member of NACES (National Association of Credential Evaluation Services) is available upon request.
Selected achievements
EQT
N/A
N/A
N/A
- Developed ‘write_2_azure’ function in R to QC the written data frames prior to truncating existing tables by adding proper error handling techniques and logging the errors in the relevant database. This prevented erroneous data to be fed downstream and improved the stability of our scripts. The function was later promoted in the company package for the general consumption.
- Automated weekly emails pulling data from Azure SQL database and sending them to joint-venture partners using R.
- Created a Drilling Sandbox, which is a self-service Spotfire dashboard that allows the user to easily tweak a number of desired inputs and axes to answer thousands of different operational performance questions used for internal and external corporate communications, but which used to take hours to answer and verify prior to this tool’s implementation.
BP
N/A
N/A
N/A
- Developed and maintained the first Spotfire dashboards in GWO Alaska. Received global recognition from BP.
- Created “Wellbore Integrity Testing Criteria Calculator” which determines if the test pressure results meet the acceptance criteria according to “BP Site Technical Practice CRT-AK-10-45: Working with Pressure”.
- Created the Drilling Data Reporter (DDR) which is a fully automated Excel tool that pulls data from EDM oracle database and generates several performance and data quality reports.
EGYPT
N/A
N/A
N/A
- Awarded a certificate for my successful participation in the “In-House SPE Student Technical Paper Contest”, Cairo, Egypt, 2003.